Tabela LDeclarationStatus

Definicja tabeli LDeclarationStatus

Name

LDeclarationStatus

Code

LDeclarationStatus

Comment

 


Lista kolumn tabeli LDeclarationStatus

Name

Code

DeclarationStatusID

DeclarationStatusID

ContractServID

ContractServID

DeclarationID

DeclarationID

Con_ContractServID

Con_ContractServID

AccountTemplateID

AccountTemplateID

Distinction

Distinction

IsCorrect

IsCorrect

VersionNo

VersionNo

VerificationStatus

VerificationStatus

ReasonOfWithdraw

ReasonOfWithdraw

WithdrawDT

WithdrawDT

CorrectionReason

CorrectionReason


Kolumna DeclarationStatusID tabeli LDeclarationStatus

Definicja kolumny DeclarationStatusID tabeli LDeclarationStatus

Name

DeclarationStatusID

Code

DeclarationStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServID tabeli LDeclarationStatus

Definicja kolumny ContractServID tabeli LDeclarationStatus

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DeclarationID tabeli LDeclarationStatus

Definicja kolumny DeclarationID tabeli LDeclarationStatus

Name

DeclarationID

Code

DeclarationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Con_ContractServID tabeli LDeclarationStatus

Definicja kolumny Con_ContractServID tabeli LDeclarationStatus

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountTemplateID tabeli LDeclarationStatus

Definicja kolumny AccountTemplateID tabeli LDeclarationStatus

Name

AccountTemplateID

Code

AccountTemplateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Distinction tabeli LDeclarationStatus

Definicja kolumny Distinction tabeli LDeclarationStatus

Name

Distinction

Code

Distinction

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IsCorrect tabeli LDeclarationStatus

Definicja kolumny IsCorrect tabeli LDeclarationStatus

Name

IsCorrect

Code

IsCorrect

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna VersionNo tabeli LDeclarationStatus

Definicja kolumny VersionNo tabeli LDeclarationStatus

Name

VersionNo

Code

VersionNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna VerificationStatus tabeli LDeclarationStatus

Definicja kolumny VerificationStatus tabeli LDeclarationStatus

Name

VerificationStatus

Code

VerificationStatus

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna ReasonOfWithdraw tabeli LDeclarationStatus

Definicja kolumny ReasonOfWithdraw tabeli LDeclarationStatus

Name

ReasonOfWithdraw

Code

ReasonOfWithdraw

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WithdrawDT tabeli LDeclarationStatus

Definicja kolumny WithdrawDT tabeli LDeclarationStatus

Name

WithdrawDT

Code

WithdrawDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CorrectionReason tabeli LDeclarationStatus

Definicja kolumny CorrectionReason tabeli LDeclarationStatus

Name

CorrectionReason

Code

CorrectionReason

Data Type

NUMBER(10)

Mandatory

No

Comment

Przyczyna korekty deklaracji


Lista kluczy tabeli LDeclarationStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LDeclarationStatus

Definicja klucza Identifier_1 tabeli LDeclarationStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment